Inline query: 
It is the query where in the place of table name we are writing one more query which makes inline query

Ex: select * from (Select * from emp);

Select ename, sal from (select * from emp); => It will display ename & sal columns

select ename from (select job, sal, deptno from emp) => It will throw error as ename column is not present in the inner query.

select * from (select ename, job from emp)=> It will display ename & job columns


Q: Display second half of the records?
Ans:select * from (select * from emp order by rownum desc) 
where rownum <= (select count(*)/2 from emp) order by empno asc


Q: Display middle records?
Ans:
select * from (select rownum as val, empno, ename, job, deptno from emp) where val between 5 and 10;
